Rename A Table

ALTER TABLE String target_table RENAME TO String new_name;

Description

Changes the table name

Arguments

String target_table

The current table name you wish to change.

String new_name

The new table name you want to rename it to.

Examples

Example 1

This command will rename a table

ALTER TABLE users RENAME TO admins;